package com.google.careerexplorernative;

import android.provider.BaseColumns;

/**
 * Defines a the OOH data schema
 * Created by jessicag on 8/15/14.
 */
public final class OohContract {
    public OohContract() {}

    public static abstract class OohEntry implements BaseColumns {
        public static final String TABLE_NAME = "ooh_table";
        public static final String COLUMN_NAME_LINK = "link";
        public static final String COLUMN_NAME_JOB_GROUP = "job_group";
        public static final String COLUMN_NAME_TITLE = "title";
        public static final String COLUMN_NAME_EDUCATION = "education";
        public static final String COLUMN_NAME_TRAINING = "training";
        public static final String COLUMN_NAME_NUMBER_GROWTH = "number_growth";
        public static final String COLUMN_NAME_PERCENT_GROWTH = "percent_growth";
        public static final String COLUMN_NAME_ANNUAL_SALARY = "annual_salary";
    }

    private static final String TEXT_TYPE = " TEXT";
    private static final String INT_TYPE = " INT";
    private static final String COMMA_SEP = ",";
    private static final String SQL_CREATE_ENTRIES =
            "CREATE TABLE " + OohEntry.TABLE_NAME + " (" +
            OohEntry._ID + " INTEGER PRIMARY KEY," +
            OohEntry.COLUMN_NAME_LINK + TEXT_TYPE + COMMA_SEP +
            OohEntry.COLUMN_NAME_JOB_GROUP + TEXT_TYPE + COMMA_SEP +
            OohEntry.COLUMN_NAME_TITLE + TEXT_TYPE + COMMA_SEP +
            OohEntry.COLUMN_NAME_EDUCATION + INT_TYPE + COMMA_SEP +
            OohEntry.COLUMN_NAME_TRAINING + INT_TYPE + COMMA_SEP +
            OohEntry.COLUMN_NAME_NUMBER_GROWTH + INT_TYPE + COMMA_SEP +
            OohEntry.COLUMN_NAME_PERCENT_GROWTH + INT_TYPE + COMMA_SEP +
            OohEntry.COLUMN_NAME_ANNUAL_SALARY + INT_TYPE + COMMA_SEP +
            " )";
    private static final String SQL_DELETE_ENTRIES =
            "DROP TABLE IF EXISTS " + OohEntry.TABLE_NAME;
}
